CREATE TABLE [dbo].[Role]
(
[MemberId] [int] NOT NULL,
[EventId] [int] NOT NULL,
[IsManager] [bit] NOT NULL,
[Description] [nvarchar] (max) COLLATE Arabic_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Role] ADD CONSTRAINT [FK_Role_Event] FOREIGN KEY ([EventId]) REFERENCES [dbo].[Event] ([Id])
GO
ALTER TABLE [dbo].[Role] ADD CONSTRAINT [FK_Role_Member] FOREIGN KEY ([MemberId]) REFERENCES [dbo].[Member] ([Id])
GO
